package com.ch.dsms_backend.repository;

import java.util.List;
import java.util.Map;

import com.ch.dsms_backend.entity.BUser;
import com.ch.dsms_backend.entity.Order;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

@Mapper
public interface UserAndOrderAndOutRepository {


    List<Map<String,Object>> getOrderAmountAndOrderdate();

    List<Map<String,Object>> selectOrdersByStatus(int status);

    List<Map<String,Object>> selectAllOrders();


    List<Map<String,Object>> selectOrderByUserName(String username);

    List<Map<String,Object>> selectOrderDetail(int id);


    List<BUser> selectUserByPage(@Param("startIndex") int startIndex, @Param("perPageSize") int perPageSize);
    int selectAllUser();
    List<Map<String,Object>> selectCartUser(int id);
    List<Map<String,Object>> selectOrderUser(int id);
    int deleteUser(int id);
    int selectAllOrder();
    List<Map<String,Object>> selectOrderByPage(@Param("startIndex") int startIndex,@Param("perPageSize") int perPageSize);
}
